/**
  设置树的根节点
 */
SET FOREIGN_KEY_CHECKS = 0;
REPLACE INTO jc_department (id, d_name, d_state)
VALUES (1, '全部', 1);
REPLACE INTO product_file_category (id, pf_name, pf_state)
VALUES (1, '全部', 1);
SET FOREIGN_KEY_CHECKS = 1;


/*
 Navicat Premium Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 50725
 Source Host           : localhost:3306
 Source Schema         : xms_account

 Target Server Type    : MySQL
 Target Server Version : 50725
 File Encoding         : 65001

 Date: 17/01/2021 15:53:32
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu`
(
    `id`        INT(11)                                                NOT NULL AUTO_INCREMENT COMMENT '自增主键',
    `parent_id` INT(11)                                                NULL DEFAULT NULL COMMENT '父节点',
    `menu_name` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单名',
    `menu_path` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单相对路径',
    `menu_icon` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单图标',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `sys_menu_parent_id_index` (`parent_id`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 14
  CHARACTER SET = utf8
  COLLATE = utf8_general_ci COMMENT = '菜单表';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu`
VALUES (1, NULL, '计划管理', '/', 'eject-aside-icon-gur-project-08'),
       (2, NULL, '基础资料', '/', 'eject-aside-icon-gur-project-34'),
       (3, 2, '往来单位', 'jc_contactcompany', ''),
       (4, 2, '部门员工', 'jc_employee', ''),
       (5, 2, '存货档案', 'jc_product_file', ''),
       (6, 2, '用户', 'jc_user', ''),
       (7, 2, '仓库', 'jc_store', NULL),
       (8, 1, '销售订单', 'jh_order_bill', ''),
       (9, 1, '销售计划', 'jh_plan_order_bill', NULL),
       (10, 1, '销售订单序时表', 'jh_order_bill_report', NULL),
       (11, 1, '销售计划序时表', 'jh_plan_order_bill_report', NULL),
       (12, 1, '计划日报表', 'jh_plan_bill', NULL),
       (13, 1, '日报表序时表', 'jh_plan_bill_report', NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;